How to: Change Control Source for text box when field name in table has changed.
Solution:
In the Form Design view, use the 'Control Source' property box in the property sheet of the form to change the 'Control Source' property for a text box.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list box. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Click on the desired text box in the form.
6) Select the 'View' menu and select 'Properties'.
7) Click the 'Data' tab.
8) Click on the 'Control Source' box. (A down arrow appears.)
9) Click down arrow. (A drop-down list appears.)
10) Select the new field name from the 'Control Source' drop-down list.
11) Select the 'File' menu and select 'Save' to save the form.
